#!/bin/sh

read -p "username: " username
stty -echo
read -p "password: " password
stty echo
echo ''

creds="-h localhost --username=$username"

PGPASSWORD=$password

db=test

dropdb -e $creds $db
createdb $creds $db
psql $creds $db -f schema.sql
psql $creds $db -f init.sql
psql $creds $db -f test.sql
